Setting Trigger Properties

Use the Trigger Name edit box to set the trigger name. This must be distinct from the name of any other trigger for the same table.

For each
This specifies whether the trigger procedure should be fired once for every row affected by the trigger event, or just once per SQL statement.

Function Schema and Function
A user-supplied function that is declared as taking no arguments and returning type trigger, which is executed when the trigger fires.

Arguments
An optional comma-separated list of arguments to be provided to the function when the trigger is executed. The arguments are literal string constants. Simple names and numeric constants may be written here, too, but they will all be converted to strings. Please check the description of the implementation language of the trigger function about how the trigger arguments are accessible within the function; it may be different from normal function arguments.

The Comment edit box defines the comment for the trigger.

Use the Fires dropdown list to define the trigger action time. It can be before or after to indicate that the trigger activates before or after the statement that activated it.

Insert
The trigger is activated whenever a new row is inserted into the table.

Update
The trigger is activated whenever a row is modified.

Delete
The trigger is activated whenever a row is deleted from the table.